Effecting Database Transformations Using Morphase

Database transformations are a frequent problem for data managers supporting scientific databases, particularly those connected with the Human Genome Project. The databases involved frequently contain complex data-structures not typically found in conventional databases, such as arbitrarily nested records, sets, variants and optional fields, as well as object identities and recursive data-structures. Furthermore, programs implementing the transformations must be frequently modified since the databases involved evolve rapidly, as often as 3 to 4 times a year. We present in this paper a language (WOL) for specifying transformations between such databases and describe its implementation in a system called Morphase. Optimizations are performed at all stages, with significant impact on the compilation and execution time of sample transformations. Comments Originally published as University of Pennsylvania Department of Computer and Information Science Technical Report No. MS-CIS-96-05. This technical report is available at ScholarlyCommons: http://repository.upenn.edu/db_research/16 ! "# $ % ! '&( % *) +-,/.1032-46587 9 :<;>=@?BA C D =FE GIH ;%J/? K L%M@NPORQTS’w ‰[‰[‘en“Tˆ ”d? •P– J/? —˜9RC ™ J ; š — › ^>œ6]fL _bknLžŸL%]f XL%thL%r¢¡$^TNfghQ _b^Tt › ^T£bQX]^`N\Q ]\r¤x z-UVrwkltmQXNf]\Q _¢¥6QF^ a x ŸL%]f XL%thL%rFxbUVy¦{`}F§ |X ̈[O ~VjTƒu„©…6a«‰FŽ­¬w®T‰[ ̄ °ž®>‡n±` ̄FŠ6„m2 „©‘h3 ®` ́